#!/usr/bin/python3.5
# -*- coding utf-8
import pymysql

# 连接数据库
db = pymysql.connect("127.0.0.1", "root", "root", "py_flask")
cursor = db.cursor()
sql = "select * from f_user"
# 执行
cursor.execute(sql)
# 获取值
resultList = cursor.fetchall()
for row in resultList:
    userId = row[0]
    username = row[1]
    password = row[2]
    phone = row[3]
    modifyDate = row[4]
    createDate = row[5]
    print(1111)
    print("userId=%s,username=%s,password=%s,phone=%s,modifyDate=%s,createDate=%s"\
          %(userId, username, password, phone, modifyDate, createDate))

print("hah")